Query Design dialog box

DacEasy Accounting for Windows includes a custom report writer, DacAccess, that allows you to create reports from any file in the database. Creating a report using DacAccess is a two-step process. First, select the information you want to see on the report using the Query. Then, define how you want to see the information using the Publisher.

Note: When you upgrade from a version earlier than Version 5, listing reports that exist in the Report Generator convert into a Query and Publisher report. The information from the Record Selection screen becomes the Query and the information from the Report Generator screen becomes the report layout in the Publisher.

Fields on the Query Design dialog box

Name

To create a new query, enter a unique name that helps you identify the query. To edit an existing query, enter the name or click LookUp and select the query.

Catalog

Click LookUp and select the catalog that contains the files to include on the report. Each catalog contains all files that are logically associated.

Column Selection area

Row 1—Column Name

Enter the fields to include in the query on the first row in the Column Selection area. To insert a field, click LookUp and the Table LookUp displays. Select the table that contains the field to include in the current column, and then select the field from the Column LookUp.

To delete a column, click Options and select Column Delete. To insert a column, click Options and select Column Insert.

Tip: In addition to selecting fields from the data files, you can create formulas to include on the report. Click here for more information on creating user-defined fields.

If you want to use a field as a user-defined column or only for sorting purposes, you must select the field as a column; however, the field does not have to print on the report. Select fields to print on the report from the Publisher. Click here for more information.

Note: After a table has been selected, the Column LookUp displays for the last selected Table when you click LookUp from the Column Selection area. To choose a different table, press Esc and select a new table.

Rows 2-3—Criterion

When creating queries you may want to limit the data retrieved. You can use logical operators such as greater than >, less than <, or equal to =, to select records. For example, if the field selected is transaction number, enter >0000000100 to include all transactions greater than 100. The following operators are available when creating logic statements.

Operator	Description
=	x equal to y
<>	x not equal to y
<	x less than y
<=	x less than or equal to y
>	x greater than y
>=	x greater than or equal to y
And	x And y
Or	x Or y
Between	Between x And y, including both x and y
Date()	Current date
Zoom

To access the Zoom field, click Options from and Criterion field, and then click Zoom. This field allows you to enter an expression in the Criterion field up to 68 characters long.

Sort Columns area

The Sort option determines how the data is displayed when the query is processed. To access the Sort Columns, click Options from the Column Selection area and select Sort Columns. Select the primary sort field in the first box. For additional sorting, enter up to three additional sort fields. The precedence of sorting is from left to right. If Sort Columns are not selected the sort order will be based on the first column in the query.

Tip: The sorting order defaults to ascending order. Click Switch Sort to toggle between ascending and descending order.


Creating a query

DacEasy Accounting for Windows includes a custom report writer, DacAccess, that allows you to create reports from any file in the database. Creating a report using DacAccess is a two-step process. First, select the information you want to see in the report using the Query. Then, define how you want to see the information using the Publisher.

To create a query

1.	Select Query from the DacAccess menu. The Query Design dialog box displays.

2.	Assign the query a unique name (up to 14 characters). If you are editing an existing query, enter the name of the query or click LookUp and select the query.

3.	Select the catalog that contains the files to include on the report. The cursor advances to the first row of the Column Selection area. Use this row to select the fields to include in the query.

Tip: Columns scroll as you move to the right. Press Home to return to the first column.

4.	Click LookUp and the Table LookUp displays. Select the table that contains the field to include in the current column and the Column LookUp displays; select the field to include in the current column from this LookUp.

Tip: In addition to selecting fields from the data files, you can create formulas to include on the report. Click here for more information on creating user defined fields. Each field in the user defined field’s formula, in addition to fields selected as sort fields, must be included in the query. You can exclude the field from the printed report using the Publisher. Click here for more information.

Note: When you click LookUp from the Column Selection area, the Column LookUp displays for the last Table selected. To choose a different table, click Close and select a new table.

5.	To edit the Column Heading on the printed report, click Options and select Edit Column. You can edit the Title field; however, the new column title only displays when you run the query and does not display on the Query Design dialog box.

6.	If necessary, limit the records to include on the query. The second and third rows in the Column Selection area determine which records to include on the report. If you leave these rows blank, DacEasy includes all records in the query. Click here for more information on limiting records in the Query.

7.	If you want to set the sorting order, click Options and select Sort Columns. The cursor advances to the first field in the Sort Columns area. Click LookUp and select the primary sort field for the report. To add a secondary sort, enter a different field in the second field in the Sort Columns area. You can enter up to four sort fields.

Note: If you do not specify a sorting order, DacEasy sorts by the field in the first column.

Tip: Click Switch Sort to toggle between ascending and descending order for the selected sort field.

8.	Click Run Query to view the query to the screen. Click the Close button to return to the Query Design dialog box.

Tip: To redirect the report to the printer, click Print.

9.	Click Process to save the query.

Note: Use the Publisher to define the report layout. Click here for more information.


Printing queries

To create a custom report using DacAccess, you select the information to include on the report from the Query Design dialog box and use the Publisher to print the final report. To quickly view the information without any formatting, you can print the report from the Query.

To print a query

1.	Select Query from the DacAccess menu. The Query Design dialog box displays.

2.	Enter the query name or click LookUp and select the query.

3. 	Click Run Query. The query displays on the screen.

4.	Click Print. The Report Disposition dialog box displays.

5.	Select the output and press click Process to view the query.


Column Information dialog box

You can view information about each field on a query and edit the field title from the Column Information dialog box. To access this dialog box, select the field in the Query Design dialog box, and then click Options and select Edit Column. You can edit the Title field; however, the new column title only displays when you run the query and does not display on the Query Design dialog box.


User Defined Field dialog box

You can add user defined fields to your query. A user defined field consists of a mathematical expression involving one or more fields. To add a user defined field, click Options from the Column Selection area on the Query Design dialog box, and then select Edit Expression.

Note: Each field used in the expression must be selected as a column on the Query Design dialog box.

Fields on the User Defined Field dialog box

Name

Enter a descriptive name for the field.

Description

Enter a description of the field.

Expression:

Enter a mathematical expression. To select a field, enter the field name or click LookUp and select the field. For example, to divide the current balance by 12; enter Current Balance/12.

Because it is possible to have columns with identically named fields, it is necessary in certain situations to supply the table name from which the field originated. For example, there is a field called INVAMT in both the Billing and the Accounts Receivable Open Invoice files. If the query includes both fields and you want to use one of the fields in a formula, you must supply the name of the table from which the field came (e.g., Arop.InvAmt). If the field name is more than one word you must enclose the field name in brackets (e.g., Arop.[Sale Tax]). The table name displays when you click LookUp from the Expression field.


Creating user defined fields in a query

In addition to selecting predefined fields in a query, you can select user defined fields. A user defined field allows you to perform a mathematical operation using one or more fields. For example, if you want to calculate a customer’s average sales per month, you could define a field called AvgMonth and enter the following formula: SalesAmtYTD/12.

Tip: After you create a user defined field, you must select the field to include it on the query. Place your cursor in the desired column on the Query Design dialog box and click LookUp; select User Defined Fields from the Table LookUp, and then select the field from the User Defined Column LookUp.

To create user defined fields

1.	Click Options and select Edit Expression from the Column Selection area on the Query Design dialog box. The User Defined Field dialog box displays.

Tip: Click here for more information on creating a query.

2.	Enter a name and description for the field.

3.	Enter the expression. To select a field, enter the field name or click LookUp and select the field. For example, to divide the current balance by 12; enter Current Balance/12.

Because it is possible to have columns with identically named fields, it is necessary in certain situations to supply the table name from which the field originated. For example, there is a field called INVAMT in both the Billing and the Accounts Receivable Open Invoice files. If the query includes both fields and you want to use one of the fields in a formula, you must supply the name of the table from which the field came (e.g., Arop.InvAmt). If the field name is more than one word you must enclose the field name in brackets (e.g., Arop.[Sale Tax]). The table name displays when you click LookUp from the Expression field.

Note: To use a field in a formula, you must first select the field as a column. In addition, the field must be a decimal quantity or numeric field. Fields with Qty as part of the name are decimal fields. Fields with Units as part of the name cannot be used in an expression. For example, Order Qty is a numeric field where Order Units is not.

4.	Click Process to save the user defined field.


Join Editing dialog box

When selecting files to use in a query, several of these files may contain the same information. For example the Receivables Header and the Receivables Open Invoice contain the Customer Code. This field is considered the join between these files. There are three types of joins, Equi, Left Outer and Right Outer. The default is an equi-join.

Equi Join—This is the default. Only data that is common between the files will be included in the queried data.

Left Outer—This join will include all receivables header transactions and only the open invoices that have a customer code in the receivables header file.

Right Outer—This join will include all open invoices and only the receivables header transactions that have a customer code in the open invoice file.

To edit the default, click Options from the Column Selection area on the Query Design dialog box and select Edit Join. The Join Editing dialog box displays. Select the type of join and click Process.


Limiting records on a query

You can limit the records to include on a query. The second and third rows in the Column Selection area on the Query Design dialog box determine which records to include on the report. If you leave these rows blank, DacEasy includes all records for the field in a query.

To limit records on a query

1.	Position your cursor in the appropriate box below the field used to limit the query (as described below).

There is an OR relationship between rows and an AND relationship between columns. DacEasy satisfies all AND criteria before satisfying the OR criteria.

For example, if you use the customer catalog and want to include customers who live in Plano OR who have a last sales date before March 1, 1999; enter Plano in the first row below the City field and enter <03/01/99 in the second row below the LastSaleDate field. The query would include all customers in Plano, in addition to all customers with a last sales date before March 1 (DacEasy does not duplicate records that meet both criteria).

On the other hand, if you use the customer catalog and want to include customers who live in Plano AND who have a last sales date before March 1, 1999, enter Plano in the first row below the City field and enter <03/01/99 in the first row below the LastSaleDate field. The query would include all customers in Plano that have a last sales date before March 1 (DacEasy does not duplicate records that meet both criteria).

2.	Enter the criterion for the field.

Enter a value in the field to include only those records that have the specified value in this field.

To specify a range of records based on a particular expression, enter the expression. You can click LookUp to select an operand. For example, to include all records greater than or equal to 1000, click LookUp, select >=, and then enter 1000.

Tip: You can enter up to 18 characters in the column. If you need to enter a longer expression, click Options and select Zoom. The cursor advances to the Zoom field where you can enter up to 68 characters.

Note: The format used to enter data in an expression depends on the field type. Click Options and select Edit Column to view a field's Data Type. Click here for more information on the format to use when entering an expression.

3.	If you selected fields from two different files and want to edit the join, click Options and select Edit Join. The Join Editing dialog box displays. Select the type of join and click Process to return to the Query Design dialog box.

There are three different types of joins: equi, left outer, and right outer. DacEasy uses the equi-join by default, which includes only records found in both files.

If you select a left outer join, the query includes all records from the first file and only those records in the second file where the joined fields are equal.

If you select a right outer join, the query includes all records from the second file and only those records in the first file where the joined fields are equal.

For example, assume you create a query using the customer code, receivable transaction amounts and open invoices. Receivable transaction amounts are in the Receivables file and open invoices are in the Open Invoice file. The customer code is in both files. Therefore, Customer Code is the link between the two files or the join. If you do not edit the join, the query will only include invoices with a customer code found in both the Open Invoice file and the Receivables file. Select a left join to include all receivables transactions and only the open invoices with a customer found in the Receivables file. Select a right join to include all open invoices and only the receivables transactions that have a customer found in the Open Invoice file.


Query/Report Copy dialog box

You can copy a query or publisher report to another set of data files (company) or to the same set with a different name. This features saves you time when you need to create a query or report similar to one that already exists. To use the Copy feature, click Options and select Copy Query (to copy a query) or Copy Report to copy a report in the Publisher.

Fields on the Query/Report Copy dialog box

Copy to Another Company

Select Yes if you want to copy the query or report to another company.

Directory Name/Path

Enter the directory name to which you want to copy the format. This field is only accessible if you selected Yes in the previous field.

New Query/Report Name

Enter the new name that you want to give to the copied query or report.


Copying queries

You can copy a query to another set of data files (company) or to the same set with a different name. This features saves you time when you need to create a query similar to an existing one.

To copy a query

1.	Select Query from the DacAccess menu. The Query Design dialog box displays.

2.	Assign the query a unique name (up to 14 characters) or click LookUp to copy an existing Query.

3.	Click Options and select Copy Query. The Query Copy dialog box displays.

4.	Complete each field.

Tip: Click Help from the Query Copy dialog box for a detailed description of each field.

5.	Click Process to copy the format. This function only copies to Query; however, when you copy a Publisher report, DacEasy also copies the corresponding query. For information on copying the report layout in the Publisher, click here.


Report Editor dialog box

Use the Publisher to layout the information specified in a query and produce a professional custom report. To use this feature, select Publisher from the DacAccess menu and the Report Editor dialog box displays.

Fields on the Report Editor dialog box

Report Name

Type a name for a report. You can use up to fourteen characters to title your report.  If you want to edit or print an existing report, enter the report name

Data Source

Enter the name of the query that you want to associate with this report or click LookUp and select the query from the list that displays.

Report Editor detail

When creating the report you are able to enter data into different areas of the report. Each area is described below:

Page Header

This is the top portion of the report. Enter your company information and report title here. You can enter text or click LookUp and select fields you want to print in the header portion.

Note: Query fields are used for column headings.

Detail

This is the body of the report. Click LookUp from this area and select fields you want to print in the body of the report or type text to include in the body of the report.

Group Footer

This section is for your subtotals. Click LookUp and select fields you want to subtotal for each group.

Report Footer

Click LookUp to select fields to include in your grand totals.

Editing Keys
Cursor Movement
HOME	Beginning of line
END	End of line
CTRL-HOME	Top of file
CTRL-END	End of file
Editing
BACK SPACE	Deletes cursor character and moves left.
DELETE	Deletes cursor character and moves right or deletes the current field being edited to a buffer.
Block Mode
Alt-C	Copy a field to a buffer
Alt-P	Paste a field from a buffer
Mouse Action
Left Button	Single click will locate the cursor to the mouse position if valid. While editing a field you may place the mouse on the field and drag the field to a new location by holding down the left mouse button.
Right Button	Escape


Creating a custom report using the Publisher

Use the Publisher to layout the information specified in a query and produce a professional custom report.

To create a custom report with the Publisher

1.	Select Publisher from the DacAccess menu. The Report Editor dialog box displays.

2.	Enter a unique name for the report. The Report Defaults dialog box displays.

3.	Complete each field on the Report Defaults dialog box.

4.	In the Data Source field, enter the query name from which you want to create the report or click LookUp and select the query.

Note: The Query details the information to include on the report and must be created before the report can be laid out in the Publisher. For more information on creating a query, click here.

5.	Enter a heading for the report in the Page Header section. You can enter text or click LookUp and select a variable. If you want column headings to print on each page, enter the headings in this section.

Note: You can select the following types of variables: Company Text, Control Fields and Query Fields. Company Text allows you to select variables corresponding to the information you entered about your company. Control Variables include the current system date, time and page number. Query fields selected in the Page Header area are inserted as text fields to be used as column headings.

Tip: Click Options and select Center to center the lines of text or variables on the report.

6.	Enter the query fields to include on the report in the Detail section. You can enter text or place fields in this section.

To insert a query field, click LookUp and select the field. If you need to include a field that is not in the list, you must edit the Query. The field is inserted at the cursor position. You can use the mouse to drag a query field to a different location.

Continue placing fields into this section until all necessary fields are on the layout. It may take some trial and error to line up the fields with your column headings.

7.	If you set a sorting order in the query, you may want each sort group to have a total. To include a subtotal on sorted fields, enter text to describe the total, and then place the field you want totaled in the Group Footer section. If you do not want sort totals, leave this section blank.

Note: If no fields are selected in the Sort Columns section on your query, DacEasy uses the field in the first column of the query as the sort field.

8.	To include grand totals on the report, select each field to total in the Report Footer section. You can also enter text in this section.

Tip: Press Enter from any field to edit the formatting. Click Help from the Field Edit dialog box for a detailed description of each formatting option.


Printing custom reports with the Publisher

DacEasy Accounting for Windows includes a custom report writer, DacAccess, that allows you to create reports from any file in the database. Creating a report using DacAccess is a two-step process. First, select the information you want to see in the report using the Query. Then, define how you want to see the information using the Publisher. Print the report from the publisher.

To print a custom report in the publisher

1.	Select Publisher from the DacAccess menu.

2.	Enter the report name or click LookUp and select the report.

3. 	Complete the fields on the Report Defaults dialog box or accept the defaults.

Tip: Click Help from the Report Defaults dialog box for a detailed description of each field.

4.	Click Print. The Report Disposition dialog box displays.

5.	Select the output and click Process to view the report.


Copying report layouts in the publisher

You can copy your report layout to another set of company data files or to the same set with a different name. This is useful if you need another report similar to the one you are using. If you copy a report, the new report uses the same query as the original. Therefore, if you change the original query, it changes the records selected for the original report and those used in the copied report.

To copy a report layout

1.	Select Publisher from the DacAccess menu. The Report Editor dialog box displays.

2.	Assign the report a unique name (up to 14 characters) or click LookUp to copy an existing report layout.

3.	Click Options and select Copy Report. The Report Copy dialog box displays.

4.	Complete each field.

Tip: Click Help from the Report Copy dialog box for a detailed description of each field.

5.	Click Process to copy the report layout. DacEasy also copies the corresponding query.


Report Defaults dialog box

Define printing options for your custom DacAccess reports on the Report Defaults dialog box. This dialog box displays automatically after you enter the report name on the Report Editor dialog box.

Fields on the Report Defaults dialog box

Print Mode

Select the print mode for the report. The report prints according to the settings entered for Normal and Condensed on the Edit Printers dialog box.

Report Width

Enter the number of columns across the width of your paper; usually 80 for normal print and 132 for condensed print.

Page Break on Group Footers

Select Yes to produce a page break after each time a subtotal is printed on the report.


Field Edit dialog box

You can format fields selected in the Publisher. To edit a field, highlight the field and press Enter. The Field Edit dialog box displays.

Fields on the Field Edit dialog box

Description

By default, the internal field name displays, though you can edit this to something more descriptive if needed,

Field Width

If you want to shorten or lengthen a field, you can edit this value to reflect that need.

Field Format

Use this field to specify the format for your date, number, and percentage fields.

Comma Formatted

Select Yes to format your numbers with commas separating the thousands, millions, etc.

Rounding

Use the Rounding field to select the precision of printed dollar amounts on the report.

Hide duplicates

Select Yes in this field and duplicate values will only print once.


Btrieve Error

There is something wrong with a file DacEasy is currently trying to open or update. Perform these steps to correct the problem:

1.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

2.	Delete all files that end with a PRE extension from the program and data files folders. These pre-imaging files created during report generation remain when the program is aborted or the machine is turned off during activity in DacEasy.

3.	Use the Transaction Viewing file operation on the File Utilities dialog box to browse the files included in the query for trash.

4.	Check your system memory. Click the Windows Start button, select Settings, and then select Control Panel. Double-click the System icon. Click the Performance tab and verify that the Memory is at least 16 MB.

5.	Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space to create a pre-image file.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively.

2.	On each DOS machine, check the Free Conventional Memory. At a DOS prompt type MEM and look at the Largest Executable Program Size. This number should be above 540K.


Btrieve Error 2 An error occurred while reading from or writing to the disk.

1.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

2.	Delete all files that end with a PRE extension from the program and data files folders. These commands remove any pre-imaging files created during report generation. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.

3.	Use the Transaction Viewing file operation on the File Utilities dialog box to browse the files included in the query for trash.

4.	Check your system memory. Click the Windows Start button, select Settings, and then select Control Panel. Double-click the System icon. Click the Performance tab and verify that the Memory is at least 16 MB.

5.	Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space to create a pre-image file.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively.

2.	On each DOS machine, check the Free Conventional Memory. At a DOS prompt type MEM and look at the Largest Executable Program Size. This number should be above 540K.


Btrieve Error 3 File is not open.

Btrieve is having a problem opening the specified data file. Btrieve must successfully open the file before it can proceed with any other operations.

1.	Restart the program and perform the operation again.

2.	Uninstall and reinstall the program.

3.	Check your system memory. Click the Windows Start button, select Settings, and then select Control Panel. Double-click the System icon. Click the Performance tab and verify that the Memory is at least 16 MB.

4.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

5.	Delete all files that end with a PRE extension from the program and data files folders. These commands remove any pre-imaging files created during report generation. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively.

2.	On each DOS machine, check the Free Conventional Memory. At a DOS prompt type MEM and look at the Largest Executable Program Size. This number should be above 540K.


Btrieve Error 4 Requested key value was not found in file.

The program is trying to read or update a record that does not exist. The steps to complete depend on the function you were attempting when you received the error.

Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.


Btrieve Error 12 Requested file not found.

DacEasy is looking for a file, however, the file is either missing or the path is invalid.

If the error displays when attempting to access the DacAccess, do a directory listing of your data subdirectory. If the following files are missing: DEAQCOL, DEAQEXP, DEAQHED, DEARFLD, DEARHED, DEARTXT, you must add these files to the data files directory. (Note: The first three letters of these file names will depend on which program you are running.)

Select Open from the File menu. Click Add and create a new company with the same chart of accounts selection used in the original company. Next, use Explorer to copy the 6 files listed above from the new data subdirectory to your company’s data subdirectory. Delete the copied company from the Open Company dialog box, and then use Explorer to delete the directory.


Btrieve Error 13 Extension file not found.

DacEasy is having trouble opening a file.

1.	Restart the program and perform the operation and again.

2.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

3.	Check your system memory. Click the Windows Start button, select Settings, and then select Control Panel. Double-click the System icon. Click the Performance tab and verify that the Memory is at least 16 MB.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively.

2.	On each DOS machine, check the Free Conventional Memory. At a DOS prompt type MEM and look at the Largest Executable Program Size. This number must be above 540K.


Btrieve Error 14 Pre-image file cannot be created or opened.

DacEasy makes the changes to the data files by creating a supplemental index. These supplemental indexes are copies of the data file with an extension *.pre. The program is unable to create or open the supplemental index file.

1.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

2.	Delete all files that end with a PRE extension from the program and data files folders. These commands remove any pre-imaging files created during report generation. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.

3.	Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space to create a pre-image file.

4.	Select No in the Accelerated File Access field on the System Preferences dialog box.

5.	If this does not solve the problem, restore your latest backup.

If you are running the Dos version concurrent with the Windows version, check the following:

Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively. Reboot your computer if you make any changes to this file.


Btrieve Error 15 I/O Error occurred during pre-imaging operation.

DacEasy is having a problem reading or writing to the supplemental index. A supplemental index is a duplicate of the data file that DacEasy updates online instead of the original data file.

1.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

2.	Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space to create a pre-image file.

3.	If you are interfacing with add-on DacEasy software, make sure these programs were not installed into the same directory as Accounting.

If you are running the Dos version concurrent with the Windows version, check the following:

Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively. Reboot your computer if you make any changes to this file.


Btrieve Error 18 Disk is full and will not allow files to be expanded or records inserted.

The program failed to create or update a data file due to insufficient disk space. It is recommended that you have at least 1 MB free for the program to function properly, however, for larger data files the program may require more.

Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space to create a pre-image file.

Note: Some environments have the ability to limit disk space to certain users. In some Novell networks you can type CHKVOL at the data directory to check the available space for that user.


Btrieve Error 19 Unrecoverable Error has occurred. File integrity cannot be guaranteed. Restore the latest backup.

This problem is usually due to Btrieve having problems accessing the data files.

1.	Uninstall and reinstall the program.

2.	Run Recover on the specified data file.


Btrieve Error 20 Record Manager Inactive.

DacEasy had a problem while loading.

1.	If you are running the network version of DacEasy Accounting for Windows, the client installation routine must be run from each workstation that accesses DacEasy. Run the installation routine on each workstation and select Client as the install type.

2.	Exit and restart the program.

3.	Uninstall and reinstall the program.

4.	Perform Scandisk on the drive where the program is located.


Btrieve Error 22 Data buffer parameter is not long enough for data.

Btrieve was unable to correctly read the specified file. This is generally due to a previous version of the program accessing a set of updated data files.

1.	Uninstall and reinstall the program.

2.	Run Recover on the specified data file.


Btrieve Error 25 Create I/O Error. Possible causes: Directory full; Disk full; Disk write protected; File Open

DacEasy tried to create a data file, however, due to insufficient free disk space the data file was not created.

1.	Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space to create a pre-image file.

2.	Some systems may need to be rebooted in order to reset the disk attributes.


Btrieve Error 36 Transaction operation not loaded correctly.

DacEasy could not perform the specified task due to Btrieve loading improperly.

Note: The following solutions also apply to Btrieve Error 38 I/O Error occurred during transaction operation.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Exit DacEasy and verify that the bat file is being used to load the program. The bat file contains different parameters to load Btrieve. Make sure the bat file contains the following line:

Btrieve /M:52 /P:4096 /T:BTRIEVE.TRN /B:16 /F:60 /L:100 /E

2.	Check the Bti.cfg file. Make sure the following lines exist:

[Btrieve]

tasks=5

[Btrieve Client]

options=/L:100 /F:60 /H:60 /T:15 /M:512 /U:0 /D /B:16

trnfile=C:\

SharingOnLocalFiles=MultiEngine

SharingOnRemoteFiles=MultiEngine

EnableSharingBias=Yes

[Btrieve Dos Requester]

DataLength=4096

MultipleLoad=No

MessageCompression=No

3.	From the program directory, type DEL *.trn. This will remove all temporary transaction files.

4.	Check the Config.sys. Make sure the Files and Buffers statements are equal to 100 and 30 respectively.


Btrieve Error 37 The operation you have selected is being run on another station. You must wait until that operation is
Btrieve Error 37 The operation you have selected is being run on another station. You must wait until that operation is completed.

DacEasy attempted to perform a routine while another workstation was currently trying to perform the same function.

1.	Restart DacEasy and try the operation again.

2.	If you are running the Dos version concurrent with the Windows version, type DEL *.trn. from the DOS Accounting program directory This will remove all transaction files that may be causing the problem.


Btrieve Error 40 Maximum transaction files opened.

DacEasy attempted to perform a task and did not have the available resources to complete the operation. Either Btrieve was not configured correctly, or the Config.sys file is not setup properly to handle the requested function.

Note: The following solutions apply to Btrieve Error 47 Maximum number of files opened.

1.	Exit DacEasy and verify that the Dea.bat file is being used to load the program. The Dea.bat file contains different parameters to load Btrieve. Make sure the Dea.bat file contains the following line:

Btrieve /M:52 /P:4096 /T:BTRIEVE.TRN /B:16 /F:60 /L:100 /E

2.	Check the Bti.cfg file. Make sure the following lines exist:

[Btrieve]

tasks=5

[Btrieve Client]

options=/L:100 /F:60 /H:60 /T:15 /M:512 /U:0 /D /B:16

trnfile=C:\

SharingOnLocalFiles=MultiEngine

SharingOnRemoteFiles=MultiEngine

EnableSharingBias=Yes

[Btrieve Dos Requester]

DataLength=4096

MultipleLoad=No

MessageCompression=No

3.	Check the Config.sys. Make sure the Files and Buffers statements are equal to 100 and 30 respectively.

4.	Reboot the computer and verify that DacEasy is the only program running. There could be other programs that are using the necessary resources to complete the function.


Btrieve Error 41 Illegal operation performed during transaction.

DacEasy is trying to perform an operation that is not allowed under the current condition. This is generally a result of a corrupted program file.

1.	Restart the program and perform the operation again.

2.	Uninstall the program and reinstall.

3.	If you are running the Dos version concurrent with the Windows version, type DEL *.trn from the DOS Accounting program directory.


Btrieve Error 42 Incomplete accelerated access.

This problem is usually a result of having Yes selected in the Accelerated Access field on the System Preferences dialog box.

1.	Run Recover on the specified data file.

2.	If the error is not resolved, restore your latest backup.


Btrieve Error 59 File Already Exists.

DacEasy needed to create a data file, however, the file already exists.

If the current file is valid, rename the file and re-perform the operation. After the operation is complete, rename the original file and overwrite the new existing file.


Btrieve Error 81 File cannot be locked.

DacEasy attempted to lock a data file, however, it was unable to do so.

1.	Check your system memory. Click the Windows Start button, select Settings, and then select Control Panel. Double-click the System icon. Click the Performance tab and verify that the Memory is at least 16 MB.

2.	Verify the user attempting to perform the operation has the necessary rights on the network. Some network environments offer the ability to grant or restrict access to certain network drives.

3.	If running any periodic, posting, or utilities, verify that all users are not working in the program.

4.	If working in a network environment, make sure that all users are on the network version of the program.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively.

2.	On each DOS machine, check the Free Conventional Memory. At a DOS prompt type MEM and look at the Largest Executable Program Size. This number should be above 540K.

3.	Verify that Share.exe is loaded. You will also want to verify that the parameters for Share are /F:4096 /L:250. Some operating systems or networks will use their own version of Share. Make sure that the DOS Share is loading before all others.


Btrieve Error 84 Record is currently locked by another station. Operation must be re-executed.

DacEasy is trying to update a record, however, the program shows another user or station is currently locking the file.

1.	Restart the program and perform the operation again.

2.	Click Reset Attributes from the File Backup/Restore dialog box to reset the file attributes.

3.	Right-click the file in the Windows Explorer, and then click Properties. If the Read-only box is selected, click in the box to remove this attribute.

4.	Reboot the computer that has the data and program files residing.


Btrieve Error 85 File is currently locked by another station. Operation must be re-executed.

DacEasy is trying to update a record, however, the program shows another user or station is currently locking the file.

Note: The following solutions also apply to Btrieve Error 94 Permission Error.

1.	Restart the program and perform the operation again.

2.	Click Reset Attributes from the File Backup/Restore dialog box to reset the file attributes.

3.	Right-click the file in the Windows Explorer, and then click Properties. If the Read-only box is selected, click in the box to remove this attribute.

4.	Reboot the computer that has the data and program files residing.


Btrieve Error 86 File table is full.

DacEasy has attempted to open a group of data files, however, the maximum number of files that can be opened has been reached.


Btrieve Error 87 Handle is Full

The program attempted to open a file, however, the maximum number of File Handles was exceeded.

Turn off the Accelerated File Access on the System Preferences dialog box.

If you are running the Dos version concurrent with the Windows version, check the following:

1.	Check the FILES and BUFFERS statements in the Config.sys file. They should be set to 100 and 30 respectively.

2.	Check the Btrieve line in the Bti.cfg file. Make sure the /F:60 parameter exists.


Btrieve Error 88 Mode Error

DacEasy is attempting to open a data file, however, the status of that file is not allowing the program to continue.

1.	Verify that all users are out of the program before running any posting, periodic, or utility routines.

2.	Verify that all DacEasy programs are using the same Btrieve Version. To verify the version of Btrieve, go into the program and click Options, and then select Version. Make sure the Database Manager is version 6.15 for all workstations. To change the version of Btrieve, type Btrsetup from the program directory prompt in DOS.

3.	Run the Drop Indexes operation from the File Utilities dialog box for all data files.


Btrieve Error 93 Incompatible lock type.

Btrieve is translating the locks incorrectly and needs to be reset. Perform these steps to correct the problem:

1.	If the error displayed while running any posting or periodic routine, restore the backup made immediately prior to running the routine.

2.	DacEasy may not have been loaded properly. Restart DacEasy.

3.	Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.

4.	If you are running the Dos version concurrent with the Windows version, verify that Share.exe is loaded with the following parameters: /F:4096 /L:250. Some operating systems or networks will use their own version of Share. Make sure that the DOS Share is loading before all others.


Error #1    Insufficient system memory to run the requested function.

Check your system memory. Click the Windows Start button, select Settings, and then select Control Panel. Double-click the System icon. Click the Performance tab and verify that the Memory is at least 16 MB.


Error #2    Field cannot be left blank.

The field being processed is vital to the correct processing of either the item or transaction.  Please fill in the field and continue with the current activity.


Error #3    File handle not available to create or open file.

Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.


Error #4    Error on creating ASCII report file.

When creating the ASCII file DacEasy encountered an error.  Delete any files that begin with VF or have a .PRE extension from your hard drive.  Attempt to create a new file with a unique filename and reprocess the report.


Error #5    Error in redirecting output to COM port.

When attempting to redirect a report to the COM port DacEasy encountered an error.  Either the COM port is inactive or the printer is turned off.  Check the setup of the port and attempt the process again.


Error #6    Error in initializing COM port.

When attempting to redirect a report to the COM port DacEasy encountered an error.  Either the COM port is inactive or the printer is turned off.  Check the setup of the port and attempt the process again.


Error #7    An error has occurred reading the view file index.

Check your hard drive for and files that begin with VF or have a .PRE extension, if you find any of theses files delete them off your hard drive.


Error #8    An error has occurred reading the view file.

Check your hard drive for and files that begin with VF or have a .PRE extension, if you find any of theses files delete them off your hard drive.


Error #9    An error has occurred writing to the printer.

If program in unable to send the file to the printer.  Check your printer connections and make sure printer is on line.  Check your hard drive for any files that begin with VF or have any .PRE extensions, if you find any of these files delete them off your hard drive. If on a network, make sure your login id has creation rights.


Error #10   Pathname cannot be left blank.

When adding or copying files, a unique path must be supplied for each set of data.  Make sure to fill in the Directory/Pathname field.


Error #11   Invalid pathname/drive entered.

The path entered is incorrect or the disk being accessed has not been formatted.  Check the media and attempt the process again.


Error #12   Illegal characters used for pathname/directory.

The pathname/directory must be either letters or numbers with no spaces.  Any characters other than the normal alpha-numeric characters will cause this error.  Check the pathname and reprocess the pathname.


Error #13   An error has occurred creating or viewing the ASCII export file. The file will be truncated.

When creating the ASCII file to disk DacEasy ran out of hard disk space or the file was damaged. Check the disk free space in Explorer. Make sure that there is at least 1MB free on your hard drive. If your data files are extremely large, DacEasy may need additional disk space. You should also check for any files that begin with VF or have a .PRE extension and delete them from your hard drive.


Error #14   Paste unavailable for current field selected.

The paste option cannot be used in the currently highlighted field. Manually type the figure into the field.


Error #15   Number is larger than the current field size.

The number being entered into the current field is larger than the field allows.  Please check the amount and re-enter an amount that will fit into the field.


Error #16   Current field cannot contain a negative value.

The field highlighted currently cannot have negative figures entered into it.  Please check the amount and reprocess the field.


Error #17   Invalid date entered.

The date entered is not in the correct format,  please re-enter the date in the MMDDYY format.


Error #18   Access Denied: Password Invalid.

The password entered is not a valid password.  Please enter a correct password to allow entry into the desired function.


Error #23    Invalid extension for the type of file you have selected.

If exporting to a file you must have to correct extension. The following are correct extensions:

ASCII—TXT, or PRN

HTML—HTM, or HTML

Excel 4.0—XLS

Excel 5.0—XLS

Lotus 123 3.1—WK3

Lotus 123 for Windows—WKW


Query Error #1   Unable to find the DacEasy query files in the specified path.

If the error displays when attempting to access the DacAccess, do a directory listing of your data subdirectory. If the following files are missing: DEAQCOL, DEAQEXP, DEAQHED, DEARFLD, DEARHED, DEARTXT, you must add these files to the data files directory. (Note: The first three letters of these file names will depend on which program you are running.)

Select Open from the File menu. Click Add and create a new company with the same chart of accounts selection used in the original company. Next, use Explorer to copy the 6 files listed above from the new data subdirectory to your company’s data subdirectory. Delete the copied company from the Open Company dialog box, and then delete the directory using Explorer.


Query Error #5   No columns have been selected.

Before running a query you must enter a field for at least one column selection field.


Query Error #6   Editing of joins not available with only one file.

You must have more than one file selection in the column selection you can use the JOIN function.


Query Error #9   Unable to read primary sort column from query.

The program is unable to read the Sort column, copy the Query using the Shift+F3 and in the new report re-enter the Sort columns for the new query, you may now use this query and delete the old one.


Dictionary Error #26  Error on expression.

Expression contains unmatched or incorrect usage of parentheses.

Make sure for your expression for every open parenthesis "(" you have a closed parenthesis ")".


Dictionary Error #27  Error on expression. Expression contains consecutive operators.

You cannot have two consecutive operators in an expression.  For example, " TotAmt--SubAmt " you cannot have the two subtraction signs next each other.


Dictionary Error #28  Error on expression. Expression starts with an operator or an operator exists before a left parenthesis.

You cannot start an expression with an operator.  For example, " -(TotAmt+SubAmt) " this expression will not work because the subtraction sign is before the open parenthesis.


Dictionary Error #29  Error on expression. Expression cannot end in an operator.

You cannot end an expression with an operator.  For example, " TotPay+(TotGrand-TotPay)/ " this expression will not work because it ends with a division symbol.


Dictionary Error #30  Error on expression. Expression contains consecutive operands, or an operand exists next to an open
Dictionary Error #30  Error on expression. Expression contains consecutive operands, or an operand exists next to an open parenthesis.

You cannot have two consecutive operands in an expression, or have an operand next to an open parenthesis.  For example, " TotalAmt SubAmt " is not valid because two operands are next to each other. Likewise the expression " TotalAmt(TotSub+TotalTax) " is incorrect because it  has an operand before an open parenthesis.


Dictionary Error #35  Error on column. Expression cannot begin or end with a logical operator.

You cannot start or end an expression with a logical operator.  For example, " And >= MARCY " this expression will not work because it begins with a logical operator.


Dictionary Error #36  Error on column.
Dictionary Error #36  Error on column. Expression cannot have two consecutive logical operators.

You cannot have two consecutive logical operators in an expression.  For example, " >= MARGRET And Or MARCY ", the 'And' and the 'Or' cannot be right next to each other.


Dictionary Error #37  Error on column. Expression cannot have two consecutive comparison operators.

You cannot have two consecutive comparison operators in an expression.  For example, " >> MARCY " you cannot have the two greater than signs right next to each other.


Dictionary Error #38  Error on column. Expression cannot have two consecutive operands.

You cannot have two consecutive operands in an expression.  For example, " TotalAmt SubAmt " you cannot have the two operands next to each other.


Publisher Error #2  Line length cannot be less than 0 or greater than 255.

The Report Width field cannot hold a number less than 0 or greater than 255, make sure you have entered the correct number and reprocess.


Publisher Error #4   No field in buffer to insert.

If using the block mode and hit Alt+P to paste you must use the Alt+C first to copy the block into the buffer.


Publisher Error #5   Query does not exist.

The Query used for this publisher report does not exist or has been deleted.


Publisher Error #13  Invalid field position.  Fields cannot overlap or extend beyond last column.

The field width for that field has extended or overlapped another field.  Check the field width and make sure it does not extend into the next field or go beyond the end of the page.


Publisher Error #14  Field width cannot be less than or equal to zero.

You may not edit the field width to be 0 or less than 0.


Join prompt

For queries containing more than two files, select Yes to include all of the detail file records. Select No to only include records where the joined fields are equal.


Error #19    No Records Found in Range

There are no items in the data range entered. Check the range and attempt the function again.


Error #20    This date is not found in the Periods Table, or the Periods has not been set up.

The Periods Table is set for a different year than that of the transaction or it has not been setup at all.  Check the date of the transaction being entered and that the Periods Table has been setup. To setup the periods table, select Defaults from the Edit menu, and then select Company Information. Edit the Period information, if necessary, and then click Process to save the company information.


Query Error #2   Column selected must be numeric

The column used for a mathematic expression or formula must be numeric or decimal quantity in order to calculate correctly.  To check what type of field you are working with in the column selection, click Options from the field, and then select Edit Column.  The Column Information displays. The data type must be decimal quantity or numeric to be used in an expression.  For example, if you are using the OrderUnits field from the Billing header in Accounting this field is not numeric, it is based on the products sales fraction.  You should use the OrderQty (Decimal) field because it is a numeric field and can be use in the expression.


Query Error #3   Insufficient line length to insert column operand

When entering an expression you have 59 characters per line.  If your expression goes beyond 59 characters you need to go to the next line to complete the operand.


Query Error #4   Column editing not available on blank columns.

The column you are trying to edit is blank (has not field assigned to it), exit out of the error and move to a column that has a field assigned to it and try to operation again.


Query Error #8   Sort column selected is not used in the query

Each field used in the Sort Columns area on the Query Design dialog box must be included in the Column Selection area. Either add the field to the Column Selection area or select a different sort field. To edit the sort field, click Options, and then select Sort Columns.


Query Error #11  Invalid query name, query already exists.

When copying a query you must give the query a different name that does not already exist in your query files.


Query Error #12  Query name cannot be blank

The Query name is vital to process the operation.  Please fill in the Query Name and continue with the current operation.


Query Error #13  Only alphabetic, numeric, and the underscore character,"_", are valid expression column name characters.

When entering the expression name use only alphabetic, numeric, and the underscore character (e.g.,Do not use any of the following:!,#,$,%,^,&)


Query Error #14  Sort column selected is already in use.

A field cannot be used more than once in the sort column selection. Check the fields you have selected in the sort column option.


Query Error #15   Query cannot be deleted because it is used as a data source for a publisher report.

Before you can delete the query, you must go to DacAccess/Publisher and delete all publisher reports using the query you want to delete as a data source.


Query Error #16   Expression cannot be saved because all expression lines are blank.

You cannot save this expression because the four lines available for expressions are blank.


Dictionary Error #1   Invalid file handle, file not open or handle corrupted.

Use Explorer to delete any files that begin with TBL from the data files directory. TBL files are created during report generation and are deleted when the process completes successfully. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.


Dictionary Error #10  Column array is uninitialized.

Use Explorer to delete any files that begin with TBL from the data files directory. TBL files are created during report generation and are deleted when the process completes successfully. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.


Dictionary Error #11  Column array is full

There is a maximum of 96 column selections allowed in the query. Check the number of columns you have selected.


Dictionary Error #13  EOF on column array read.

Use Explorer to delete any files that begin with TBL from the data files directory. TBL files are created during report generation and are deleted when the process completes successfully. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.


Dictionary Error #14  Column name does not exist in column array.

A field used in an expression does not exist as a column in the query or had been deleted. Find the field used in the expression and add it as a column in the column selection of the query.


Dictionary Error #16  Table array full

There is a maximum of 96 column selections allowed in the query. Check the number of columns you have selected.


Dictionary Error #19  Unable to create temporary table file name.

Use Explorer to delete any files that begin with TBL from the data files directory. TBL files are created during report generation and are deleted when the process completes successfully. These files remain when the program is aborted or the machine is turned off during activity in DacEasy.


Dictionary Error #23  No records found selected from query.

Delete all criteria from the query (e.g., >= 12/31/99).  Run the query and verify that all criteria used previously appear on the query result table.


Dictionary Error #24  The expression is too complicated, simplify the expression.

The program is unable to calculate the expression.  Check all columns used in the expression and simplify the expression.


Dictionary Error #25  The following column used in the expression is non-numeric

The column used for a mathematic expression or formula must be numeric or decimal quantity in order to calculate correctly.  To check what type of field you are working with in the column selection, click Options from the field, and then select Edit Column.  The Column Information displays. The data type must be decimal quantity or numeric to be used in an expression.  For example, if you are using the OrderUnits field from the Billing header in Accounting this field is not numeric, it is based on the products sales fraction.  You should use the OrderQty (Decimal) field because it is a numeric field and can be use in the expression.


Dictionary Error #33  The expression is too complicated, simplify the expression.

The program is unable to calculate the expression.  Check all columns used in the expression and simplify the expression.


Publisher Error #1    Report name cannot be blank.

The Report name is vital to process the operation.  Please fill in the Report Name and continue with the current operation.


Publisher Error #6    Cannot center a line containing data fields.

When centering a line, you can only center Company Text. Furthermore, no Query Fields or Control Fields can be on the same line as the Company Text you are trying to center.


Publisher Error #7    Only fields selected in the Detail can be used in the Group and Report Footer.

Check all fields used in the Group and Report Footer and make sure they are in the Detail section on the report.  If the fields are not present in the detail selection, select another field for the Group or Report Footer or place the chosen field in the Detail section of the report.


Publisher Error #8   Error copying Report Header.

Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.


Publisher Error #9   Error copying Report Text.

Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.


Publisher Error #10   Error copying Report Fields.

Select Utilities from the File menu. Recover each Query file, Publisher file, and any files included on the query. Verify each transaction header file and open invoice file included on the query.

Tip: Click LookUp from the File Selection field to select each file.


Publisher Error #11  Field does not exist in query.

Continue through the error, when the query runs and displays the publisher report, the field name will appear in the column where the field does not exist in the query used as the Data Source. Delete the field off the Publisher report or go the DacAccess, Query and add the missing field back to the query.


Publisher Error #15  Invalid Report name, report already exists.

When copying a Report you must give the Report a different name that does not already exist in your Report files.


Query Error #18      The catalog cannot be changed if query columns have already been selected.

Once you have selected the columns for the query you cannot go back and change the catalog because you may try to select a catalog that does not include the files needed for the selected columns. If you wish to change the catalog, click Delete to start a new query.


User does not have access to this function.

The user name you have entered is not setup to access the function you are trying to enter.


User ID Does not Exist in the Users file.

The user id you have supplied does not exist in the User Id file. The User to copy from must be a valid user id.